package com.loongtech.bi.manager.game;

import java.util.List;

import org.springframework.stereotype.Service;

import com.loongtech.bi.entity.game.EntityLocationConstant;
import com.loongtech.core.jpa.manager.ManagerQueryCacheBase;
/**
 * 用户登录ip分布
 * @author lihui
 *
 */
@Service
public class LocationConstantManager extends ManagerQueryCacheBase<EntityLocationConstant> {
	private static final long serialVersionUID = 1L;
	
	/**
	 * 根据开始结束时间求
	 * @param dateStart
	 * @param dateEnd
	 * @param type
	 * @return
	 */
	public List<Object[]> getCityNameByCityId(String cityId) {
		return findByQuery("select cityName,cityId from EntityLocationConstant where cityId = '"+ cityId +"'");
	}
	
	/**
	 * 根据开始结束时间求
	 * @param dateStart
	 * @param dateEnd
	 * @param type
	 * @return
	 */
	public List<Object[]> getprovinceNameByProvinceId(String provinceId) {
		return findByQuery("select provinceName,provinceId from EntityLocationConstant where provinceId = '"+ provinceId +"'");
	}
}
